📝 Create Record
The Create Record action allows you to insert a new record into a specified database table by defining values for its columns.
Configuration
- Name: Enter a descriptive name for the create record action.
- Select Source: Choose the data source or connection from which to create the record.
- Select Schema: Select the database schema where the target table resides.
- Select Table: Choose the table where the new record will be inserted.
- Select Column: Define one or more columns and their values to be set for the new record. For each column:
- Select the column name.
- Enter the value or use an expression (fx) to dynamically assign it.
- Use the plus (+) button to add more columns or the trash icon to remove.
Features
- Supports inserting records with multiple column values.
- Allows dynamic value assignment using expressions.
- Integrates with various data sources and schemas.
- Provides flexible configuration for diverse database structures.
Use Cases
- Add new entries to user, order, or product tables.
- Populate audit logs or transaction records.
- Create linked records during complex workflows.
- Insert data gathered from user inputs or external sources.
Notes
- Ensure the selected source, schema, and table exist and are accessible.
- Validate column data types and constraints to prevent insertion errors.
- Use expressions to set values based on workflow variables or calculations.
Tip: Combine Create Record with other data actions like Filter or Select to automate data population workflows.